Fric-frac Laravel CRUD
Home

Fric-frac Laravel CRUD

Fric-frac Laravel CRUD

Dit artikel legt stap voor stap uit hoe je CRUD toepassingen maakt in laravel 7.

Stappenplan

  1. Open de map fric-frac-laravel in Visual Studio Code
  2. Elk Laravel-project bevat het .env-bestand. Daarin bewaar je alle databaseconfiguraties, zoals database-inloggegevens, details van mailprogramma's, enz. Open het .env bestand:
    Laravel env file
    Laravel env file
  3. Database configuratie In de databaseconfiguratie geven we de host, de poort, databasenaam, gebruikersnaam, wachtwoord op. Open .env-bestand en vul de details. Als je met een lokale MySql server werkt: 
    DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Fricfrac
DB_USERNAME=root
DB_PASSWORD=
    Ik gebruik de remote MySql database: 
    DB_CONNECTION=mysql
DB_HOST=51.38.37.150
DB_PORT=3306
DB_DATABASE=Docent1
DB_USERNAME=Docent1
DB_PASSWORD=Docent_XXXXXXXX
  4. Voer de volgende opdracht uit in de terminal om de configuratiecache leeg te maken: 
    php artisan config:clear
  5. Migration (voor de EventCategory tabel)
    1. Open de terminal
    2. We gaan een CRUD applicatie voor EventCategory. We beginnen met een migratie voor de tabel EventCategory. We gebruiken daarvoor de Laravel 7 php artisan-opdracht: 
      php artisan make:model EventCategory -m
      Vanaf Laravel 8 wordt het model geplaatst in de map app/models. Verplaats het model naar de app map om de code in de cursus te laten werken.
      Als je een databasemigratie mogelijk wilt maken wanneer het model gegenereerd wordt, moet je de optie --migration of -m gebruiken.
    3. Deze opdracht creëert een bestand met de naam 2020_05_10_131509_create_event_categories_table.php in de map database/migrations. Let erop dat Larabel automatisch de naam voor de tabel verandert in event_categories. Je past de code aan om de EventCategory tabel te maken: 
      <?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateEventCategoriesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('event_categories', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('event_categories');
    }
}
    4. Voer de volgende opdracht uit om de tabel in de database aan te maken: 
      php artisan migrate
    5. Open de database in Workbench:
      De tabel event_categories in Workbench
      De tabel event_categories in Workbench
  6. Open de routes/web.php pagina en voeg de volgende route toe: 
    <?php
use Illuminate\Support\Facades\Route;
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
Route::get('/', function () {
    return view('welcome');
});
Route::resource('eventcategory','EventCategoryController');

    Vanaf Laravel 8:

    Route::resource('eventcategory','app\Http\Controllers\EventCategoryController');
  7. Voeg de EventCategoryController en het EventCategory model toe. Typ in de terminal: 
    php artisan make:controller EventCategoryController --resource --model=EventCategory
  8. Pas het model in het bestand app/EventCategory.php aan: 
    <?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class EventCategory extends Model
{
    protected $fillable = [
        'name'
    ];
}
  9. In het bestand app/Http/Controllers/EventCategoryController.php passen we de volgende methoden aan: 
    <?php
/*
https://www.positronx.io/php-laravel-crud-operations-mysql-tutorial/
https://www.itsolutionstuff.com/post/laravel-7-crud-example-laravel-7-tutorial-for-beginnersexample.html
*/
namespace App\Http\Controllers;

use App\EventCategory;
use Illuminate\Http\Request;

class EventCategoryController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $eventCategory = EventCategory::all();
        return view('eventcategory.index', compact('eventCategory'));
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('eventcategory.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */

    public function store(Request $request)
    {
        $request->validate([
            'name' => 'required',
        ]);
        EventCategory::create($request->all());
        return redirect()->route('eventcategory.index')

            ->with('success', 'EventCategory created successfully.');
    }

    /**
     * Display the specified resource.
     *
     * @param  \App\EventCategory  $eventCategory
     * @return \Illuminate\Http\Response
     */
    public function show(EventCategory $eventCategory)
    {
        //
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\EventCategory  $eventCategory
     * @return \Illuminate\Http\Response
     */
    public function edit(EventCategory $eventCategory)
    {
        //
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\EventCategory  $eventCategory
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, EventCategory $eventCategory)
    {
        //
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\EventCategory  $eventCategory
     * @return \Illuminate\Http\Response
     */
    public function destroy(EventCategory $eventCategory)
    {
        //
    }
}
  10. Laravel gebruikt standaard Bootstrap voor de lay-out.
    We maken de volgende blade views aan:
  11. de masterpage (pagina gedeeld door alle views) resources/views/layout.blade.php: 
    <!DOCTYPE html>
<html>
<head>
    <title>Laravel 7 CRUD Application - ItSolutionStuff.com</title>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha/css/bootstrap.css" rel="stylesheet">
</head>

<body>
<div class="container">
    @yield('content')
</div>
</body>
</html>
  12. de resources/views/eventcategory/index.blade.php view: 
    @extends('layout')
@section('content')
    <div class="row">
        <div class="col-lg-12 margin-tb">
            <div class="pull-left">
                <h2>Laravel 7 CRUD Fric-frac</h2>
            </div>
            <div class="pull-right">
                <a class="btn btn-success" href="{{ route('eventcategory.create') }}"> Create New EventCategory</a>
            </div>
        </div>
    </div>
    @if ($message = Session::get('success'))
        <div class="alert alert-success">
            <p>{{ $message }}</p>
        </div>
    @endif
    <table class="table table-bordered">
        <tr>
            <th>No</th>
            <th>Name</th>
            <th width="280px">Action</th>
        </tr>
        @foreach ($eventCategory as $item)
        <tr>
            <td>{{ $item->id }}</td>
            <td>{{ $item->name }}</td>
        </tr>
        @endforeach
    </table>
 @endsection
  13. de resources/views/eventcategory/create.blade.php view: 
    @extends('layout')
@section('content')
<div class="row">
    <div class="col-lg-12 margin-tb">
        <div class="pull-left">
            <h2>Add New EventCategory</h2>
       </div>
        <div class="pull-right">
            <a class="btn btn-primary" href="{{ route('eventcategory.index') }}"> Back</a>
        </div>
    </div>
</div>

@if ($errors->any())
    <div class="alert alert-danger">
        <strong>Whoops!</strong> There were some problems with your input.<br><br>
        <ul>
            @foreach ($errors->all() as $error)
                <li>{{ $error }}</li>
            @endforeach
        </ul>
    </div>
@endif

<form action="{{ route('eventcategory.store') }}" method="POST">
    @csrf
     <div class="row">
        <div class="col-xs-12 col-sm-12 col-md-12">
            <div class="form-group">
                <strong>Name:</strong>
                <input type="text" name="name" class="form-control" placeholder="Name">
            </div>
        </div>
        <div class="col-xs-12 col-sm-12 col-md-12 text-center">
                <button type="submit" class="btn btn-primary">Submit</button>
        </div>
    </div>
</form>
@endsection
  14. tart de webserver op. Typ in de terminal in de map programmeren4/laravel/fric-frac-laravel: 
    Sphp artisan serve --port=63342
  15. In de browser typ je de url:
    http://localhost:63343/eventcategory/
  16. Met dit als resultaat:
    fric-frac-laravel EventCategory index view
    fric-frac-laravel EventCategory index view
  17. Als je op Create New EventCategory klikt:
    fric-frac-laravel EventCategory create view
    fric-frac-laravel EventCategory create view

JI
2021-05-10 17:43:37